iMIS Database Maintenance (DB Maintenance) is a standalone application that replaced the iMIS 10 Table Analysis utility. This tool lets you rebuild, analyze, and manage all iMIS tables. It also lets you run special scripts that prepare your database to support advanced options, such as PCI, NRDS, and VAT.
Tip: The DB Maintenance utility replaces DB Repair.
DB Maintenance runs as a separate, local application from the iMIS program group and organizes helpful database commands on a set of tabs.
■ Change Connection – Switch to another iMIS database.
■ Output – Displays information about the functions performed; this information also writes to a log file in the executable's directory.
■ Analyze Database – Run a full analysis on the entire iMIS database. This process performs an extensive database analysis, so allow ample time for it to run.
Table analysis testing:
□ missing table
□ missing or extra columns
□ wrong column order, data type, length, or defaults
□ wrong numeric precision, scale, radix
□ missing index
□ missing PK/unique/clustered index
□ missing or disabled triggers
□ missing or disabled/distrusted foreign keys
■ Prepare iMIS Database – Prepare an iMIS database that has just been restored to a new location or under a new name.
■ Table Details – Analyze, examine, reset, or rebuild individual tables.
Precautions for using DB Maintenance
■ Verify that you have a valid backup of your iMIS database before running DB Maintenance commands that modify the database.
■ Ensure the database is protected from updates before modifying it, to prevent failures and data problems from changes occurring while entities are being reset/rebuilt/removed:
1. Have all users log out.
2. Stop webservers from updating the database, such as by stopping the AppPool in IIS.
■ While users are logged in, you can safely run Analyze Database and Table Details; however, analyzing the database can affect performance.